package com.zhen.Mapper;

import com.zhen.User.Riqi;
import lombok.Data;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface OtherMapper {
    @Select("select * from rili")
    public List<Riqi> selectrili();
    @Select("select * from class1")
    public List<Riqi> selectclass1();
    @Select("select * from class2")
    public List<Riqi> selectclass2();
    @Insert("insert into class1(riqi, content) " +
            "values(#{riqi},#{content})")
    public Integer insertclass1(Riqi riqi);
    @Insert("insert into class2(riqi, content) " +
            "values(#{riqi},#{content})")
    public Integer insertclass2(Riqi riqi);
    @Insert("insert into rili(riqi, content) " +
            "values(#{riqi},#{content})")
    public Integer insertriqi(Riqi riqi);
//    删除日历信息
    @Delete("delete from rili where riqi=#{riqi}")
    public Integer deleterili(@Param("riqi") String riqi);
    @Delete("delete from class1 where riqi=#{riqi}")
    public Integer deleteclass1(@Param("riqi") String riqi);
    @Delete("delete from class2 where riqi=#{riqi}")
    public Integer deleteclass2(@Param("riqi") String riqi);

}
